SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vweNomenclador
AS
SELECT     idCargo AS ID, cargo, Puntos
FROM         dbo.tb_CargosSalariales
GO
GRANT SELECT ON  [dbo].[vweNomenclador] TO [Informatica]
GRANT UPDATE ON  [dbo].[vweNomenclador] TO [Informatica]
GRANT SELECT ON  [dbo].[vweNomenclador] TO [PersonalDocente]
GRANT UPDATE ON  [dbo].[vweNomenclador] TO [PersonalDocente]
GRANT SELECT ON  [dbo].[vweNomenclador] TO [SoloVer]
GRANT SELECT ON  [dbo].[vweNomenclador] TO [Subsidios]
GRANT INSERT ON  [dbo].[vweNomenclador] TO [Subsidios]
GRANT UPDATE ON  [dbo].[vweNomenclador] TO [Subsidios]
GRANT SELECT ON  [dbo].[vweNomenclador] TO [SubsidiosConsulta]
GO
